Dataset statistics
| Number of variables | 9 |
|---|---|
| Number of observations | 590 |
| Missing cells | 1494 |
| Missing cells (%) | 28.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 41.6 KiB |
| Average record size in memory | 72.2 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 8 |
Variable descriptions
| Leaded Regular Gasoline, U.S. City Average Retail Price | Price of leaded fuel, 0 when discontinued |
|---|---|
| Unleaded Regular Gasoline, U.S. City Average Retail Price | Price of unleaded fuel, 0 when leaded was used |
| Unleaded Premium Gasoline, U.S. City Average Retail Price | Price of premium unleaded fuel |
| All Grades of Gasoline, U.S. City Average Retail Price | Cumulative of all grades of gasoline |
| Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price | Price of fuel, non-blended |
| Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price | Price of fuel, blended |
| Regular Motor Gasoline, All Areas, Retail Price | Cumulative mean of all categories |
| On-Highway Diesel Fuel Price | Price for diesel fuel |
Leaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 2 other fields | High correlation |
Unleaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
Unleaded Premium Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
All Grades of Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Regular Motor Gasoline, All Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
On-Highway Diesel Fuel Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Leaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 2 other fields | High correlation |
Unleaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
Unleaded Premium Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
All Grades of Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Regular Motor Gasoline, All Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
On-Highway Diesel Fuel Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Leaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 2 other fields | High correlation |
Unleaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
Unleaded Premium Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
All Grades of Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Regular Motor Gasoline, All Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
On-Highway Diesel Fuel Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Leaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 2 other fields | High correlation |
Unleaded Regular Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
Unleaded Premium Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
All Grades of Gasoline, U.S. City Average Retail Price is highly correlated with Leaded Regular Gasoline, U.S. City Average Retail Price and 6 other fields | High correlation |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Regular Motor Gasoline, All Areas, Retail Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
On-Highway Diesel Fuel Price is highly correlated with Unleaded Regular Gasoline, U.S. City Average Retail Price and 5 other fields | High correlation |
Leaded Regular Gasoline, U.S. City Average Retail Price has 370 (62.7%) missing values | Missing |
Unleaded Regular Gasoline, U.S. City Average Retail Price has 36 (6.1%) missing values | Missing |
Unleaded Premium Gasoline, U.S. City Average Retail Price has 104 (17.6%) missing values | Missing |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price has 228 (38.6%) missing values | Missing |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price has 264 (44.7%) missing values | Missing |
Regular Motor Gasoline, All Areas, Retail Price has 228 (38.6%) missing values | Missing |
On-Highway Diesel Fuel Price has 264 (44.7%) missing values | Missing |
Date has unique values | Unique |
Reproduction
| Analysis started | 2022-08-10 09:18:16.613359 |
|---|---|
| Analysis finished | 2022-08-10 09:18:25.240754 |
| Duration | 8.63 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 590 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.7 KiB |
| Minimum | 1973-01-01 00:00:00 |
|---|---|
| Maximum | 2022-02-01 00:00:00 |
Leaded Regular Gasoline, U.S. City Average Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice of leaded fuel, 0 when discontinued
| Distinct | 181 |
|---|---|
| Distinct (%) | 82.3% |
| Missing | 370 |
| Missing (%) | 62.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9052363636 |
| Minimum | 0.402 |
|---|---|
| Maximum | 1.354 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.402 |
|---|---|
| 5-th percentile | 0.5318 |
| Q1 | 0.61175 |
| median | 0.9255 |
| Q3 | 1.14425 |
| 95-th percentile | 1.2993 |
| Maximum | 1.354 |
| Range | 0.952 |
| Interquartile range (IQR) | 0.5325 |
Descriptive statistics
| Standard deviation | 0.2703439861 |
|---|---|
| Coefficient of variation (CV) | 0.298644638 |
| Kurtosis | -1.39437006 |
| Mean | 0.9052363636 |
| Median Absolute Deviation (MAD) | 0.265 |
| Skewness | -0.1098260417 |
| Sum | 199.152 |
| Variance | 0.07308587082 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.55 | 5 | 0.8% |
| 0.528 | 4 | 0.7% |
| 1.197 | 3 | 0.5% |
| 1.297 | 2 | 0.3% |
| 0.6 | 2 | 0.3% |
| 0.607 | 2 | 0.3% |
| 0.626 | 2 | 0.3% |
| 0.63 | 2 | 0.3% |
| 0.629 | 2 | 0.3% |
| 0.627 | 2 | 0.3% |
| Other values (171) | 194 | |
| (Missing) | 370 |
| Value | Count | Frequency (%) |
| 0.402 | 1 | 0.2% |
| 0.418 | 1 | 0.2% |
| 0.437 | 1 | 0.2% |
| 0.465 | 2 | |
| 0.491 | 2 | |
| 0.528 | 4 | |
| 0.532 | 1 | 0.2% |
| 0.533 | 1 | 0.2% |
| 0.534 | 2 | |
| 0.537 | 2 |
| Value | Count | Frequency (%) |
| 1.354 | 1 | |
| 1.352 | 1 | |
| 1.351 | 1 | |
| 1.344 | 1 | |
| 1.335 | 1 | |
| 1.333 | 1 | |
| 1.324 | 1 | |
| 1.321 | 1 | |
| 1.315 | 1 | |
| 1.31 | 1 |
Unleaded Regular Gasoline, U.S. City Average Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice of unleaded fuel, 0 when leaded was used
| Distinct | 474 |
|---|---|
| Distinct (%) | 85.6% |
| Missing | 36 |
| Missing (%) | 6.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.773546931 |
| Minimum | 0.592 |
|---|---|
| Maximum | 4.09 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.592 |
|---|---|
| 5-th percentile | 0.66665 |
| Q1 | 1.11925 |
| median | 1.327 |
| Q3 | 2.48375 |
| 95-th percentile | 3.5907 |
| Maximum | 4.09 |
| Range | 3.498 |
| Interquartile range (IQR) | 1.3645 |
Descriptive statistics
| Standard deviation | 0.9010155023 |
|---|---|
| Coefficient of variation (CV) | 0.5080302564 |
| Kurtosis | -0.5891162738 |
| Mean | 1.773546931 |
| Median Absolute Deviation (MAD) | 0.3955 |
| Skewness | 0.7944872424 |
| Sum | 982.545 |
| Variance | 0.8118289354 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.955 | 4 | 0.7% |
| 1.131 | 4 | 0.7% |
| 1.127 | 3 | 0.5% |
| 1.207 | 3 | 0.5% |
| 1.136 | 3 | 0.5% |
| 1.177 | 3 | 0.5% |
| 1.255 | 3 | 0.5% |
| 1.25 | 3 | 0.5% |
| 1.241 | 3 | 0.5% |
| 0.665 | 3 | 0.5% |
| Other values (464) | 522 | |
| (Missing) | 36 | 6.1% |
| Value | Count | Frequency (%) |
| 0.592 | 1 | |
| 0.594 | 1 | |
| 0.6 | 2 | |
| 0.605 | 1 | |
| 0.616 | 1 | |
| 0.623 | 1 | |
| 0.626 | 1 | |
| 0.627 | 1 | |
| 0.628 | 1 | |
| 0.629 | 2 |
| Value | Count | Frequency (%) |
| 4.09 | 1 | |
| 4.065 | 1 | |
| 3.933 | 1 | |
| 3.927 | 1 | |
| 3.868 | 1 | |
| 3.856 | 1 | |
| 3.816 | 1 | |
| 3.792 | 1 | |
| 3.786 | 2 | |
| 3.764 | 1 |
Unleaded Premium Gasoline, U.S. City Average Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice of premium unleaded fuel
| Distinct | 428 |
|---|---|
| Distinct (%) | 88.1% |
| Missing | 104 |
| Missing (%) | 17.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.15823251 |
| Minimum | 0.98 |
|---|---|
| Maximum | 4.35 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.98 |
|---|---|
| 5-th percentile | 1.115 |
| Q1 | 1.33625 |
| median | 1.6805 |
| Q3 | 3.00075 |
| 95-th percentile | 3.9555 |
| Maximum | 4.35 |
| Range | 3.37 |
| Interquartile range (IQR) | 1.6645 |
Descriptive statistics
| Standard deviation | 0.9755398661 |
|---|---|
| Coefficient of variation (CV) | 0.4520086976 |
| Kurtosis | -1.079366983 |
| Mean | 2.15823251 |
| Median Absolute Deviation (MAD) | 0.51 |
| Skewness | 0.6107838416 |
| Sum | 1048.901 |
| Variance | 0.9516780304 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.421 | 3 | 0.5% |
| 1.411 | 3 | 0.5% |
| 1.367 | 3 | 0.5% |
| 1.268 | 3 | 0.5% |
| 1.36 | 3 | 0.5% |
| 1.441 | 2 | 0.3% |
| 1.323 | 2 | 0.3% |
| 1.339 | 2 | 0.3% |
| 1.282 | 2 | 0.3% |
| 1.1 | 2 | 0.3% |
| Other values (418) | 461 | |
| (Missing) | 104 | 17.6% |
| Value | Count | Frequency (%) |
| 0.98 | 1 | |
| 0.984 | 1 | |
| 0.987 | 1 | |
| 0.999 | 1 | |
| 1.007 | 1 | |
| 1.01 | 1 | |
| 1.045 | 1 | |
| 1.047 | 1 | |
| 1.052 | 1 | |
| 1.061 | 1 |
| Value | Count | Frequency (%) |
| 4.35 | 1 | |
| 4.319 | 1 | |
| 4.244 | 1 | |
| 4.194 | 1 | |
| 4.192 | 1 | |
| 4.148 | 1 | |
| 4.14 | 1 | |
| 4.138 | 1 | |
| 4.102 | 1 | |
| 4.1 | 1 |
All Grades of Gasoline, U.S. City Average Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONCumulative of all grades of gasoline
| Distinct | 441 |
|---|---|
| Distinct (%) | 74.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.741944068 |
| Minimum | 0.629 |
|---|---|
| Maximum | 4.142 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.629 |
|---|---|
| 5-th percentile | 0.6406 |
| Q1 | 1.11975 |
| median | 1.3085 |
| Q3 | 2.4325 |
| 95-th percentile | 3.6193 |
| Maximum | 4.142 |
| Range | 3.513 |
| Interquartile range (IQR) | 1.31275 |
Descriptive statistics
| Standard deviation | 0.9293758199 |
|---|---|
| Coefficient of variation (CV) | 0.5335279341 |
| Kurtosis | -0.5415937419 |
| Mean | 1.741944068 |
| Median Absolute Deviation (MAD) | 0.48 |
| Skewness | 0.8022571739 |
| Sum | 1027.747 |
| Variance | 0.8637394145 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.631 | 12 | 2.0% |
| 0.629 | 12 | 2.0% |
| 0.637 | 6 | 1.0% |
| 0.645 | 6 | 1.0% |
| 0.655 | 6 | 1.0% |
| 0.663 | 6 | 1.0% |
| 0.669 | 6 | 1.0% |
| 0.671 | 6 | 1.0% |
| 0.676 | 6 | 1.0% |
| 0.685 | 6 | 1.0% |
| Other values (431) | 518 |
| Value | Count | Frequency (%) |
| 0.629 | 12 | |
| 0.631 | 12 | |
| 0.637 | 6 | |
| 0.645 | 6 | |
| 0.655 | 6 | |
| 0.663 | 6 | |
| 0.669 | 6 | |
| 0.671 | 6 | |
| 0.676 | 6 | |
| 0.685 | 6 |
| Value | Count | Frequency (%) |
| 4.142 | 1 | |
| 4.115 | 1 | |
| 3.982 | 1 | |
| 3.976 | 1 | |
| 3.918 | 1 | |
| 3.908 | 1 | |
| 3.863 | 1 | |
| 3.839 | 2 | |
| 3.838 | 1 | |
| 3.813 | 1 |
Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice of fuel, non-blended
| Distinct | 331 |
|---|---|
| Distinct (%) | 91.4% |
| Missing | 228 |
| Missing (%) | 38.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.098372928 |
| Minimum | 0.9 |
|---|---|
| Maximum | 4.002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.9 |
|---|---|
| 5-th percentile | 1.03915 |
| Q1 | 1.22175 |
| median | 2.105 |
| Q3 | 2.76875 |
| 95-th percentile | 3.6048 |
| Maximum | 4.002 |
| Range | 3.102 |
| Interquartile range (IQR) | 1.547 |
Descriptive statistics
| Standard deviation | 0.8629110184 |
|---|---|
| Coefficient of variation (CV) | 0.4112286271 |
| Kurtosis | -1.112339466 |
| Mean | 2.098372928 |
| Median Absolute Deviation (MAD) | 0.757 |
| Skewness | 0.3317638835 |
| Sum | 759.611 |
| Variance | 0.7446154256 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.078 | 4 | 0.7% |
| 1.066 | 3 | 0.5% |
| 2.488 | 3 | 0.5% |
| 2.211 | 3 | 0.5% |
| 1.058 | 2 | 0.3% |
| 2.48 | 2 | 0.3% |
| 2.678 | 2 | 0.3% |
| 1.082 | 2 | 0.3% |
| 1.199 | 2 | 0.3% |
| 3.168 | 2 | 0.3% |
| Other values (321) | 337 | |
| (Missing) | 228 |
| Value | Count | Frequency (%) |
| 0.9 | 1 | |
| 0.917 | 1 | |
| 0.923 | 1 | |
| 0.961 | 1 | |
| 0.979 | 1 | |
| 0.994 | 1 | |
| 0.998 | 1 | |
| 1.006 | 2 | |
| 1.008 | 1 | |
| 1.009 | 1 |
| Value | Count | Frequency (%) |
| 4.002 | 1 | |
| 3.989 | 1 | |
| 3.849 | 1 | |
| 3.837 | 1 | |
| 3.801 | 1 | |
| 3.774 | 1 | |
| 3.746 | 1 | |
| 3.74 | 1 | |
| 3.735 | 1 | |
| 3.709 | 1 |
Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice of fuel, blended
| Distinct | 311 |
|---|---|
| Distinct (%) | 95.4% |
| Missing | 264 |
| Missing (%) | 44.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.369110429 |
| Minimum | 0.984 |
|---|---|
| Maximum | 4.19 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.984 |
|---|---|
| 5-th percentile | 1.11775 |
| Q1 | 1.51825 |
| median | 2.3835 |
| Q3 | 3.0165 |
| 95-th percentile | 3.8025 |
| Maximum | 4.19 |
| Range | 3.206 |
| Interquartile range (IQR) | 1.49825 |
Descriptive statistics
| Standard deviation | 0.8829988867 |
|---|---|
| Coefficient of variation (CV) | 0.3727132664 |
| Kurtosis | -1.155138768 |
| Mean | 2.369110429 |
| Median Absolute Deviation (MAD) | 0.7605 |
| Skewness | 0.1007680195 |
| Sum | 772.33 |
| Variance | 0.7796870339 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.129 | 2 | 0.3% |
| 1.483 | 2 | 0.3% |
| 1.5 | 2 | 0.3% |
| 1.543 | 2 | 0.3% |
| 2.663 | 2 | 0.3% |
| 1.114 | 2 | 0.3% |
| 1.307 | 2 | 0.3% |
| 2.343 | 2 | 0.3% |
| 3.202 | 2 | 0.3% |
| 2.832 | 2 | 0.3% |
| Other values (301) | 306 | |
| (Missing) | 264 |
| Value | Count | Frequency (%) |
| 0.984 | 1 | |
| 1.008 | 1 | |
| 1.016 | 1 | |
| 1.043 | 1 | |
| 1.045 | 1 | |
| 1.046 | 1 | |
| 1.054 | 1 | |
| 1.057 | 1 | |
| 1.067 | 1 | |
| 1.071 | 1 |
| Value | Count | Frequency (%) |
| 4.19 | 1 | |
| 4.187 | 1 | |
| 4.032 | 1 | |
| 4.025 | 1 | |
| 4.017 | 1 | |
| 3.949 | 1 | |
| 3.939 | 1 | |
| 3.919 | 1 | |
| 3.914 | 1 | |
| 3.86 | 1 |
Regular Motor Gasoline, All Areas, Retail Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGCumulative mean of all categories
| Distinct | 322 |
|---|---|
| Distinct (%) | 89.0% |
| Missing | 228 |
| Missing (%) | 38.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.142513812 |
| Minimum | 0.921 |
|---|---|
| Maximum | 4.062 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.921 |
|---|---|
| 5-th percentile | 1.0471 |
| Q1 | 1.23125 |
| median | 2.182 |
| Q3 | 2.80825 |
| 95-th percentile | 3.66045 |
| Maximum | 4.062 |
| Range | 3.141 |
| Interquartile range (IQR) | 1.577 |
Descriptive statistics
| Standard deviation | 0.8830022923 |
|---|---|
| Coefficient of variation (CV) | 0.4121337689 |
| Kurtosis | -1.151839223 |
| Mean | 2.142513812 |
| Median Absolute Deviation (MAD) | 0.785 |
| Skewness | 0.2915628142 |
| Sum | 775.59 |
| Variance | 0.7796930483 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.114 | 4 | 0.7% |
| 1.078 | 4 | 0.7% |
| 2.836 | 3 | 0.5% |
| 1.131 | 3 | 0.5% |
| 1.111 | 3 | 0.5% |
| 1.062 | 3 | 0.5% |
| 2.555 | 3 | 0.5% |
| 1.969 | 2 | 0.3% |
| 1.397 | 2 | 0.3% |
| 2.859 | 2 | 0.3% |
| Other values (312) | 333 | |
| (Missing) | 228 |
| Value | Count | Frequency (%) |
| 0.921 | 1 | |
| 0.939 | 1 | |
| 0.945 | 1 | |
| 0.982 | 1 | |
| 0.995 | 1 | |
| 0.998 | 1 | |
| 1.006 | 1 | |
| 1.008 | 1 | |
| 1.009 | 2 | |
| 1.013 | 1 |
| Value | Count | Frequency (%) |
| 4.062 | 1 | |
| 4.054 | 1 | |
| 3.906 | 1 | |
| 3.9 | 1 | |
| 3.852 | 1 | |
| 3.849 | 1 | |
| 3.8 | 1 | |
| 3.779 | 1 | |
| 3.766 | 1 | |
| 3.746 | 1 |
On-Highway Diesel Fuel Price
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGPrice for diesel fuel
| Distinct | 301 |
|---|---|
| Distinct (%) | 92.3% |
| Missing | 264 |
| Missing (%) | 44.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.445389571 |
| Minimum | 0.959 |
|---|---|
| Maximum | 4.703 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.7 KiB |
Quantile statistics
| Minimum | 0.959 |
|---|---|
| 5-th percentile | 1.085 |
| Q1 | 1.42525 |
| median | 2.5105 |
| Q3 | 3.12825 |
| 95-th percentile | 3.996 |
| Maximum | 4.703 |
| Range | 3.744 |
| Interquartile range (IQR) | 1.703 |
Descriptive statistics
| Standard deviation | 1.000537845 |
|---|---|
| Coefficient of variation (CV) | 0.4091527409 |
| Kurtosis | -1.187072514 |
| Mean | 2.445389571 |
| Median Absolute Deviation (MAD) | 0.937 |
| Skewness | 0.1223904225 |
| Sum | 797.197 |
| Variance | 1.00107598 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.12 | 3 | 0.5% |
| 3.905 | 3 | 0.5% |
| 2.997 | 2 | 0.3% |
| 2.785 | 2 | 0.3% |
| 1.637 | 2 | 0.3% |
| 1.482 | 2 | 0.3% |
| 2.519 | 2 | 0.3% |
| 3.045 | 2 | 0.3% |
| 1.42 | 2 | 0.3% |
| 3.069 | 2 | 0.3% |
| Other values (291) | 304 | |
| (Missing) | 264 |
| Value | Count | Frequency (%) |
| 0.959 | 1 | |
| 0.967 | 1 | |
| 0.973 | 1 | |
| 0.997 | 1 | |
| 1.007 | 1 | |
| 1.022 | 1 | |
| 1.024 | 1 | |
| 1.029 | 1 | |
| 1.039 | 1 | |
| 1.041 | 1 |
| Value | Count | Frequency (%) |
| 4.703 | 1 | |
| 4.677 | 1 | |
| 4.425 | 1 | |
| 4.302 | 1 | |
| 4.127 | 1 | |
| 4.12 | 1 | |
| 4.115 | 1 | |
| 4.111 | 1 | |
| 4.094 | 1 | |
| 4.084 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Date | Leaded Regular Gasoline, U.S. City Average Retail Price | Unleaded Regular Gasoline, U.S. City Average Retail Price | Unleaded Premium Gasoline, U.S. City Average Retail Price | All Grades of Gasoline, U.S. City Average Retail Price | Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price | Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price | Regular Motor Gasoline, All Areas, Retail Price | On-Highway Diesel Fuel Price | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 1973-01-01 | 0.465 | NaN | NaN | 0.631 | NaN | NaN | NaN | NaN |
| 1 | 1973-02-01 | 0.491 | NaN | NaN | 0.629 | NaN | NaN | NaN | NaN |
| 2 | 1973-03-01 | 0.528 | NaN | NaN | 0.629 | NaN | NaN | NaN | NaN |
| 3 | 1973-04-01 | 0.537 | NaN | NaN | 0.631 | NaN | NaN | NaN | NaN |
| 4 | 1973-05-01 | 0.550 | NaN | NaN | 0.637 | NaN | NaN | NaN | NaN |
| 5 | 1973-06-01 | 0.556 | NaN | NaN | 0.645 | NaN | NaN | NaN | NaN |
| 6 | 1973-07-01 | 0.558 | NaN | NaN | 0.655 | NaN | NaN | NaN | NaN |
| 7 | 1973-08-01 | 0.554 | NaN | NaN | 0.663 | NaN | NaN | NaN | NaN |
| 8 | 1973-09-01 | 0.550 | NaN | NaN | 0.669 | NaN | NaN | NaN | NaN |
| 9 | 1973-10-01 | 0.402 | NaN | NaN | 0.671 | NaN | NaN | NaN | NaN |
Last rows
| Date | Leaded Regular Gasoline, U.S. City Average Retail Price | Unleaded Regular Gasoline, U.S. City Average Retail Price | Unleaded Premium Gasoline, U.S. City Average Retail Price | All Grades of Gasoline, U.S. City Average Retail Price | Regular Motor Gasoline, Conventional Gasoline Areas, Retail Price | Regular Motor Gasoline, Reformulated Gasoline Areas, Retail Price | Regular Motor Gasoline, All Areas, Retail Price | On-Highway Diesel Fuel Price | |
|---|---|---|---|---|---|---|---|---|---|
| 580 | 2021-05-01 | NaN | 2.972 | 3.596 | 3.041 | 2.885 | 3.202 | 2.985 | 3.217 |
| 581 | 2021-06-01 | NaN | 3.154 | 3.802 | 3.245 | 2.964 | 3.281 | 3.064 | 3.287 |
| 582 | 2021-07-01 | NaN | 3.233 | 3.897 | 3.326 | 3.044 | 3.339 | 3.136 | 3.339 |
| 583 | 2021-08-01 | NaN | 3.255 | 3.938 | 3.351 | 3.062 | 3.368 | 3.158 | 3.350 |
| 584 | 2021-09-01 | NaN | 3.265 | 3.945 | 3.361 | 3.081 | 3.382 | 3.175 | 3.384 |
| 585 | 2021-10-01 | NaN | 3.385 | 4.040 | 3.477 | 3.193 | 3.506 | 3.291 | 3.612 |
| 586 | 2021-11-01 | NaN | 3.482 | 4.148 | 3.576 | 3.275 | 3.659 | 3.395 | 3.727 |
| 587 | 2021-12-01 | NaN | 3.408 | 4.100 | 3.505 | 3.168 | 3.608 | 3.307 | 3.641 |
| 588 | 2022-01-01 | NaN | 3.413 | 4.102 | 3.500 | 3.187 | 3.595 | 3.315 | 3.724 |
| 589 | 2022-02-01 | NaN | 3.592 | 4.244 | 3.675 | 3.400 | 3.773 | 3.517 | 4.032 |